<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
  request.setCharacterEncoding("utf-8");
  String sno= request.getParameter("sno");
  String sdep= request.getParameter("sdep");
  String ssex= request.getParameter("ssex");
  String sage= request.getParameter("sage");
  String sname= request.getParameter("sname");
  try {
		Class.forName("com.mysql.jdbc.Driver");
		Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/teacher?useUnicode=true&characterEncoding=utf-8", "root", "123456");//获得数据库连接
		PreparedStatement st = con.prepareStatement("insert into student(sno,sdep,ssex,sage,sname) values(?,?,?,?,?)");
		st.setString(1, sno);//1代表第一个?，对应值是变量sno
		st.setString(2, sdep);
		st.setString(3, ssex);
		st.setInt(4, Integer.parseInt(sage));//4代表第一个?，对应值是变量sage解析成数值
		st.setString(5, sname);
		st.executeUpdate();
		st.close();
		con.close();
		request.getRequestDispatcher("showinfo.jsp").forward(request, response);
  }catch(Exception e){
	  e.printStackTrace();
  }
%>
</body>
</html>